Originally by: Rikkard Strofeldt

---

Edited by: Rikkard Strofeldt on 07/08/2006 12:20:03
I have the SQL for PostgreSQL. Had to mess around with it a bit, I'm using a UTF-8 system, and I'm assuming the dump was made in Win1252. Also had to screw with the reserved words as column names, and some of the field types.

I created a project on a berlios.de site and will upload my dump there after it is approved. Was going to do this ages ago, but I was always playing when I wasn't sharing the net connection. Oh well. I'll either update this post with a URL, or add another reply.

If anyone is interested in putting their dumps up here as well, join up, and when its there I can add you to the project. You don't need to join if you're just going to download the dumps.

---

postgresilise() {
 cmd="-e 's:,,:,null,:g' \
 -e 's:,):,null):g' \
 -e 's:(,:(null,:g' \
 -e 's:CHAR(400):TEXT:g' \
 -e 's:CHAR(1000):TEXT:g' \
 -e 's:CHAR(3000):TEXT:g' \
 -e 's:CHAR(4000):TEXT:g' \
 -e 's:CHAR(6000):TEXT:g' \
 -e 's:UNKNOWN:INTEGER:g' \
 -e 's:xMin:x_Min:g' \
 -e 's:yMin:y_Min:g' \
 -e 's:yMin:z_Min:g' \
 -e 's:xMax:x_Max:g' \
 -e 's:yMax:y_Max:g' \
 -e 's:zMax:z_Max:g' \
 -e 's:dbo.::g'"

 attribs="published stackable highIsGood scattered isOffensive isAssistance \
 disallowAutoRepeat published isWarpSave electronicChance propulsionChance \
 isDefault obsolete useBasePrice allowManufacture allowRecycler anchored \
 anchorable *****bleNonSingleton hasTypes border fringe corridor hub \
 international regional constellation scattered"

 for col in $attribs
 do
 cmd="${cmd} -e '/${col}/s/INTEGER/BOOLEAN/'"
 done
 cmd="sed -i $cmd *.sql"
 eval $cmd
}

Originally by: Amarr Menza

---

Hi,

The EVE data wiki is now coming on great quite a few of the Tables have been optimised and outputted in MySQL 5, I am now adding optimised CSV downloads and will add XML and SQL very soon. Plus a decent schema of the DB. Looking for support on this so if anyone wants to help out click below log in and get stuck in.

EVE Data Help

Cheers

Amarr

---

Originally by: Amarr Menza

---

Hi

Ok show me a link to this guide please.

The goal is to not provide a 'Guide' but to provide updated optimised MySQL / Postgres / any DB schemas and data exports.

As you can see from

EVE MySQL Exports

This is starting to happen now, I find the SQL generated by CCP is not indexed correctly, the fields types are obviously all a miss - so I am simply correcting all these importing in the CSV and then exporting this out again in an optimised fashion.

---

Originally by: t20

---

You'll all get the new data when Revelations (Kali) hits the deck.

---

Originally by: t20

---

data dump delayed till we're 150% confident that everything's running smooth, we've changed some "static" data that would require me to do another data dump. ETA: sooner than soon.

so until then, just be on hold.

---

Originally by: t20

---

It's on the way, izz naajs

---